SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}Aachen{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}' OR prCity = 'Aachen' OR prZip = 'Aachen' OR prStreet LIKE '{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}Aachen{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}' OR prCountry = 'Aachen') AND (prLocation LIKE '{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}/{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}/{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}' OR prCountry = '/') AND (prLocation LIKE '{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}Haaren{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}' OR prCity = 'Haaren' OR prZip = 'Haaren' OR prStreet LIKE '{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}Haaren{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}' OR prCountry = 'Haaren') AND (prLocation LIKE '{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}Germany{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}Germany{49071761d78275ce60b127a7f8f38e2347648a9e73842af63c2bb8686f2a099b}' OR prCountry = 'Germany')